1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Models
13 {
14 class DonViTinhMod
15 {
16 protected int IdDonViTinh { get; set; }
17 protected string MaDonViTinh { get; set; }
18 protected string TenDonViTinh { get; set; }
19 protected int ViTri { get; set; }
20 protected int TrangThai { get; set; }
21
22 protected int PageSize { get; set; }
23 protected int PageIndex { get; set; }
24
25
26 public DonViTinhMod(int _IdDonViTinh)
27 {
28 IdDonViTinh = _IdDonViTinh;
29 }
30
31 public DonViTinhMod()
32 {
33
34 }
35
36 public DonViTinhMod(int _pageSize, int _pageIndex)
37 {
38 PageSize = _pageSize;
39 PageIndex = _pageIndex;
40 }
41
42 public DonViTinhMod(string _maDonViTinh, string _tenDonViTinh, int _viTri, int _trangThai)
43 {
44 MaDonViTinh = _maDonViTinh;
45 TenDonViTinh = _tenDonViTinh;
46 ViTri = _viTri;
47 TrangThai = _trangThai;
48 }
49
50 public DonViTinhMod(int _idDonViTinh, string _maDonViTinh, string _tenDonViTinh, int _viTri, int _trangThai)
51 {
52 IdDonViTinh = _idDonViTinh;
53 MaDonViTinh = _maDonViTinh;
54 TenDonViTinh = _tenDonViTinh;
55 ViTri = _viTri;
56 TrangThai = _trangThai;
57 }
58
59 //Them moi dvt
60 public int InsertDonViTinh()
61 {
62 int i = 0;
63 string[] paras = new string[4] { "@MaDonViTinh", "@TenDonViTinh", "@ViTri", "@TrangThai"};
64 object[] values = new object[4] { MaDonViTinh, TenDonViTinh, ViTri, TrangThai};
65 i = Models.connection.Excute_Sql("spTblDonViTinh_Insert", CommandType.StoredProcedure, paras, values);
66 return i;
67 }
68
69 //update mod don vi tinh
70 public int UpdateDonViTinh()
71 {
72 int i = 0;
73 string[] paras = new string[5] { "@IdDonViTinh", "@MaDonViTinh", "@TenDonViTinh", "@ViTri", "@TrangThai" };
74 object[] values = new object[5] { IdDonViTinh, MaDonViTinh, TenDonViTinh, ViTri, TrangThai };
75 i = Models.connection.Excute_Sql("spTblDonViTinh_Update", CommandType.StoredProcedure, paras, values);
76 return i;
77 }
78
79 public int DeleteDonViTinh()
80 {
81 int i = 0;
82 string[] paras = new string[1] { "@IdDonViTinh" };
83 object[] values = new object[1] { IdDonViTinh };
84 i = Models.connection.Excute_Sql("spTblDonViTinh_Delete", CommandType.StoredProcedure, paras, values);
85 return i;
86 }
87
88 public DataSet FillDataSetDonViTinh()
89 {
90 DataSet ds = new DataSet();
91 ds = Models.connection.FillDataSet("spTblDonViTinh_get", CommandType.StoredProcedure);
92 return ds;
93
94 }
95
96 public DataSet FillDataSetDonViTinh_GetDanhSach()
97 {
98 DataSet ds = new DataSet();
99 ds = Models.connection.FillDataSet("spTblDonViTinh_getDanhSach", CommandType.StoredProcedure);
100 return ds;
101 }
102
103 public DataSet FillDataSet_spTblDonViTinh_Search()
104 {
105 DataSet ds = new DataSet();
106 string[] paras = new string[2] { "@PageSize", "@PageIndex" };
107 object[] values = new object[2] { PageSize, PageIndex };
108 ds = Models.connection.FillDataSet("spTblDonViTinh_Search", CommandType.StoredProcedure, paras, values);
109 return ds;
110 }
111
112
113 }
114 }